Create Staging Tables in Staging Database and Populate the Staging Tables - Continued 9

To Load Stg_Req Table:






Source Vw_ReqA:



Source VW_SIH:



Source Timing::

SQL command Text:



SQL command Text:


SELECT [Job Posting ID] ,[Supplier Response], [Selection Process], [Onboarding],

MIN ([Job Posting Approval/Distribution] ) as [Min_Job Posting Approval/Distribution]

FROM [dbo].[Timing]

Group By [Job Posting ID], [Supplier Response], [Selection Process], [Onboarding]


Sort:



Sort 1:




Sort 2:





Merge Join:




Sort 3:





Merge Join 1:





Data Conversion:




Derived Column:




Derived Column Text:


ISNULL([Str_SIH_Min Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Presented Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Max Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Presented Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Max Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Requested Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Min Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Requested Bill Rate (ST/Hr)]

ISNULL([Str_Min_Job Posting Approval/Distribution]) ? "0" : [Str_Min_Job Posting Approval/Distribution]


OLEDB Destination:






About Derived Column Transformation

https://www.sqlshack.com/ssis-derived-columns-with-multiple-expressions-vs-multiple-transformations/

Create Staging Tables in Staging Database and Populate the Staging Tables - Continued 9

To Load Stg_Req Table:






Source Vw_ReqA:



Source VW_SIH:



Source Timing::

SQL command Text:



SQL command Text:


SELECT [Job Posting ID] ,[Supplier Response], [Selection Process], [Onboarding],

MIN ([Job Posting Approval/Distribution] ) as [Min_Job Posting Approval/Distribution]

FROM [dbo].[Timing]

Group By [Job Posting ID], [Supplier Response], [Selection Process], [Onboarding]


Sort:



Sort 1:




Sort 2:





Merge Join:




Sort 3:





Merge Join 1:





Data Conversion:




Derived Column:




Derived Column Text:


ISNULL([Str_SIH_Min Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Presented Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Max Presented Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Presented Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Max Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Max Requested Bill Rate (ST/Hr)]

ISNULL([Str_SIH_Min Requested Bill Rate (ST/Hr)]) ? "0" : [Str_SIH_Min Requested Bill Rate (ST/Hr)]

ISNULL([Str_Min_Job Posting Approval/Distribution]) ? "0" : [Str_Min_Job Posting Approval/Distribution]


OLEDB Destination:






About Derived Column Transformation

https://www.sqlshack.com/ssis-derived-columns-with-multiple-expressions-vs-multiple-transformations/